[CALCITE-2478] SqlAdvisor: purge from_clause when _suggest_ token is located in one of the from sub-queries - ASF JIRA

XML

Word

Printable

JSON

Testcase:

select axc from (select (select ^ from dummy) axc from dummy a), dummy b

Expected output:

SELECT * FROM ( SELECT ( SELECT _suggest_ FROM dummy ) axc FROM dummy a )

Actual output:

SELECT * FROM ( SELECT ( SELECT _suggest_ FROM dummy ) axc FROM dummy a ) , dummy b

links to

PR 773